<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping assembly="SimCMS.Model" namespace="SimCMS.Model" xmlns="urn:nhibernate-mapping-2.2">
  <class name="SimFoodmenu" table="Sim_Foodmenu" lazy="true" >
    <id name="Id">
      <generator class="identity" />
    </id>
    <property name="FMenuName" update="false">
      <column name="FMenuName" sql-type="nvarchar" not-null="false" />
    </property>
    <property name="Material">
      <column name="Material" sql-type="nvarchar" not-null="false" />
    </property>
    <property name="Detail">
      <column name="Detail" sql-type="text" not-null="false" />
    </property>
    <property name="Pic" update="false">
      <column name="Pic" sql-type="nvarchar" not-null="false" />
    </property>
    <property name="Cid">
      <column name="Cid" sql-type="varchar" not-null="false" />
    </property>
    <property name="Url" update="false">
      <column name="Url" sql-type="nvarchar" not-null="false" />
    </property>
  </class>
  <sql-query name="Distinct"  >
    <return alias="SimFoodmenu" class="SimFoodmenu"/>
    <![CDATA[ select * from Sim_Foodmenu u Where u.FMenuName In (Select s.FMenuName From Sim_Foodmenu s Group By s.FMenuName Having Count(*)>1) Order by FMenuName desc]]>
  </sql-query>
</hibernate-mapping>